package com.supermap.agricultural_meteoro.monitor.dao;

import com.supermap.agricultural_meteoro.monitor.entity.SPSS;
import org.apache.ibatis.annotations.Mapper;
import org.apache.ibatis.annotations.Param;
import org.apache.ibatis.annotations.Select;

import java.util.List;
import java.util.Map;

@Mapper
public interface SPSSDao {

    @Select("SELECT * FROM t_product_spss_content psc " +
            "WHERE psc.userId = #{userId} " +
            "GROUP BY psc.forecastDate DESC LIMIT 10")
    public List<SPSS> getUserSPSSInformation(@Param("userId") String userId);
}
